home *** CD-ROM | disk | FTP | other *** search
/ Your Choice 3 / Your Choice Software Collection 3.iso / service / foxpro2 / foxapp.app (.txt) < prev    next >
MS Visual FoxPro App  |  1994-01-01  |  89KB  |  1,387 lines

  1. TALKz
  2. SAFETYz
  3. forceregenf
  4. TALKz
  5. COMPATIBLEz
  6. appgen
  7.  FoxPro Application Generator 
  8. addbs
  9. forceext
  10. defaultext
  11. juststem
  12. justext
  13. justpath
  14. justfname
  15. cleanpath
  16. foxapp
  17. ERROR
  18. DO apperror WITH PROGRAM(),MESSAGE(),MESSAGE(1),LINENO(),ERROR()
  19. ESCAPE
  20. DO appescape WITH PROGRAM(),MESSAGE(),MESSAGE(1),LINENO(),ERROR()
  21. fpath
  22. APPMENU.MNX
  23. COMMAND
  24. FOXAPP
  25. GENERATE
  26. Error opening CONFIG.FP.
  27. FOXAPP
  28. MENUS\APPMENU.PRG2
  29. MENUS\APPMENU.MPR2    
  30. MENUS\APPMENU.MPR
  31. COPY FILE MENUS\appmenu.prg TO &mpr_name
  32. appmenu.prg2
  33. appmenu.mpr2    
  34. appmenu.mpr
  35. COPY FILE appmenu.prg TO &mpr_name
  36. FOXAPP\MENUS\APPMENU.PRG2
  37. FOXAPP\MENUS\APPMENU.MPR2    
  38. FOXAPP\MENUS\APPMENU.MPR
  39. COPY FILE foxapp\MENUS\appmenu.prg TO &mpr_name
  40. MENUS\APPMENU.PRG2
  41. MENUS\APPMENU.MPR2    
  42. MENUS\APPMENU.MPR
  43. DELETE FILE &mpr_name
  44. appmenu.prg2
  45. appmenu.mpr2    
  46. appmenu.mpr
  47. DELETE FILE &mpr_name
  48. FOXAPP\MENUS\APPMENU.PRG2
  49. FOXAPP\MENUS\APPMENU.MPR2    
  50. FOXAPP\MENUS\APPMENU.MPR
  51. DELETE FILE &mpr_name
  52. MENUS\APPMENU.PRG2
  53. MENUS\APPMENU.MPX2    
  54. MENUS\APPMENU.MPX
  55. DELETE FILE &mpx_name
  56. appmenu.prg2
  57. appmenu.MPX2    
  58. appmenu.MPX
  59. DELETE FILE &mpx_name
  60. FOXAPP\MENUS\APPMENU.PRG2
  61. FOXAPP\MENUS\APPMENU.MPX2    
  62. FOXAPP\MENUS\APPMENU.MPX
  63. DELETE FILE &mpx_name
  64. appgen
  65. Screen name:
  66. Database name:
  67. Step 2 : Design a screen
  68. Step 1: Create or modify a database
  69. @*VN \<Create
  70. @*VN \<Modify
  71. @*VN \<File List
  72. @*HN Re\<lated...
  73. @*VN C\<reate
  74. @*VN M\<odify
  75. @*VN F\<ile List
  76. @*VN \!\<Generate
  77. @*HN \<Advanced
  78. @*VN \?\<Cancel
  79. appgen
  80. The screen file is missing.
  81. The database file is missing.
  82. Locate 
  83.  please
  84.    FoxApp has created an application named F
  85.    in the F
  86.  directory.
  87.    You can run your application now by pressing any key.
  88.    To run it in the future, simply select "Application"
  89.    from the RUN menu, or enter FoxPro and type:
  90.       SET DEFAULT TO F
  91.       DO F
  92.    Thank you for using FoxApp!
  93. Press any key to start your application.
  94. RSCUSED
  95. C:FORCEREGENAPP_TALK
  96. APP_SAFE
  97. CURRAREA
  98. NTALKSTAT
  99. COMPSTAT
  100. APPGEN
  101. ADDBS
  102. FORCEEXT
  103. DEFAULTEXTJUSTSTEM
  104. JUSTEXT
  105. PRJUSTPATH
  106. GJUSTFNAME
  107. CLEANPATH
  108. APPFILE
  109. PAMNUNAME
  110. DBFNAME
  111. PRSCXNAME
  112. REPNAME
  113. TMFNAME
  114. SKIPDBFBUTDBFLIST
  115. FIRSTTIME
  116. ORIGNAME
  117. APP_ERROR
  118. APP_ESCAPEFOXAPP
  119. APEFPATH
  120. CAPEAPPPATHLENGENERATE
  121. NCANCBUT
  122. ADDDBF
  123. ADDSCX
  124. MODSCX
  125. MODDBF
  126. COMMAND
  127. ENNUMCOLS
  128. NUMAREAS
  129. CSTEMNUM
  130. RELSTRNUM
  131. PFLDNUM
  132. xCFLDNUM
  133. CDBFNUM
  134. PDBFNUM
  135. SROWNUM
  136. SCOLNUM
  137. NSEROWNUM
  138. PRECOLNUM
  139. ARRANGED
  140. CTRLROW
  141. CTRLCOL
  142. NEXTDBF
  143. OPRSC_CHECK
  144. RSC_STOREDRETRIEVERSSTORERSC
  145. REGEN
  146. EGENFP
  147. EGENBUFFER
  148. FOXAPPDIR
  149. FINDSRC
  150. MPR_NAME
  151. MPX_NAME
  152. QUITTING
  153. _Q4E12HSXE_Q4E12HT0L_Q4E12HT8S_Q4E12HTE6LISTDBF
  154. _Q4E12HTHS_Q4E12HTK6OTHER
  155. _Q4E12HTP0_Q4E12HTSF_Q4E12HTV8_Q4E12HTZI_Q4E12HU3J_Q4E12HU6ALISTSCX
  156. _Q4E12HU9T_Q4E12HUD6ADVANCED
  157. @_Q4E12HX0F_Q4E12HX36_Q4E12HX66_Q4E12HX67CLOSE_UP
  158. 2INVSTEM
  159. CDXNAME
  160. INVERT
  161. APPDOC
  162. IN_WRAP
  163. IN_LMARGININ_RMARGININVNAME
  164. INBAILOUT
  165. S#APPSHELL
  166. 2/1/92#
  167. \LIBS\FPATH
  168. ON ERROR  &app_error
  169. ON ESCAPE &app_escape
  170. qprview.vue2
  171. qprview.vue
  172. appview.vue2
  173. appview.vue
  174. dbfselec.vue2
  175. dbfselec.vue
  176. foxapp.vue2
  177. foxapp
  178. foxapp.vue
  179. SCXNAME
  180. C:DBFNAME
  181. ENINVNAME
  182. CDXNAME
  183. REPNAME
  184. NTMFNAME
  185. BAILOUT
  186. SKIPDBFBUTORIGNAME
  187. DBFLIST
  188. MNUNAME
  189. XTAPPFILE
  190. VERSIONDATADDBS
  191. GFOXAPPDIR
  192. APP_ERROR
  193. APP_ESCAPEQPRVIEW
  194. PRAPPVIEW
  195. DBFSELEC
  196. FOXAPP
  197. APP_TALK
  198. TAPP_SAFE
  199. prgs\appproc.prg
  200. menus\appmenu.mnx
  201. menus\appmenu.mnt
  202. screens\getdest.scx
  203. screens\getdest.sct
  204. screens\getorder.scx
  205. screens\getorder.sct
  206. screens\appabout.scx
  207. screens\appabout.sct
  208. screens\appsrch.scx
  209. screens\appsrch.sct
  210. screens\prtsetup.scx
  211. screens\prtsetup.sct
  212. screens\prtopts.scx
  213. screens\prtopts.sct
  214. screens\appctrl.scx
  215. screens\appctrl.sct
  216. FXPATH
  217. C:ADDBS
  218. ENFOXAPPDIR
  219. PROJDIR
  220. JUSTPATH
  221. NAPPFILE
  222. PUTOUT
  223. PATHNAME
  224. :SOURCE
  225. ENTARGET
  226. FILNAME
  227. JUSTFNAME
  228. ADDBS
  229. FOXAPP.SRC
  230. FOXAPP.SRC
  231. FoxApp source files must be available to build projects.
  232. Please locate the FOXAPP.SRC file:
  233. FoxApp cannot build a full project without its source files.
  234. PATHz
  235. APPDIR
  236. :TARGFILE
  237. NADDBS
  238. ALERT
  239. CLOSE_UP
  240. JUSTPATH
  241. JANUARY
  242. FEBRUARY
  243. MARCH
  244. APRIL
  245. AUGUST
  246. SEPTEMBER
  247. OCTOBER
  248. NOVEMBER
  249. DECEMBER
  250. :VDATESTR
  251. NVMONTHSTR
  252. VMONTH
  253. COMPATIBLEz
  254. SAFETYz
  255. Indexing on 
  256. IF TYPE(m.fldname) = "C" AND LEN(&fldname) >= 99
  257. INDEX ON SUBSTR(&fldname,1,99) TO (m.fldname)
  258. INDEX ON &fldname TAG (m.fldname)
  259. Indexing for 
  260.  is complete!
  261. FILNAME
  262. :COMP_STAT
  263. SAFE_STAT
  264. IN_AREA
  265. FSTEM
  266. JUSTSTEM
  267. LNAME
  268. FLDNAME
  269. APPCTRL.SCX
  270. FOXAPP\SCREENS\APPCTRL.SCX
  271. SELECT &sname
  272. Master screen set record missing!
  273. SET DEFAULT TO &c_path
  274. PJXNAME
  275. :SCXNAME
  276. CTRL_Y
  277. CTRL_X
  278. IN_AREA
  279. SNAME
  280. CTRL_NAME
  281. REGEN
  282. UTCTRL_SCX
  283. ADDBS
  284. JUSTPATH
  285. TJUSTSTEM
  286. PJXFILE
  287. TTYPE
  288. GHOMENAME
  289. HOMEDIR
  290. EMODAL
  291. PRJUSTFNAME
  292. FORCEEXT
  293. SETNUM
  294. SETID
  295. ARRANGED
  296. SCRNORDER
  297. CTRL_ORDERUSER_SCX
  298. RTIMESTAMP
  299. EXCLUDE
  300. PESCRNROW
  301. NSCRNCOL
  302. NCLOSE_UP
  303. XNAME
  304. XNAME
  305. DBFLIST
  306. NUMAREAS
  307. NUMCOLS
  308. CSTEMNUM
  309. ARRANGED
  310. SROWNUM
  311. TSCOLNUM
  312. EROWNUM
  313. ECOLNUM
  314. Please locate the database
  315. FNAME
  316. :STEM
  317. JUSTSTEM
  318. Screen has been created.
  319. Database could not be opened.
  320. :MAXV
  321. S_NAME
  322. SCXNAME
  323. OPENDBF
  324. DBFNAME
  325. ADDBS
  326. JUSTPATH
  327. TJUSTSTEM
  328. ADDSCX
  329. MODSCX
  330. TVPOS
  331. WIDTH
  332. HEIGHT
  333. ECENTER
  334. PRSTYLE
  335. ERRSHOW
  336. FILNAME
  337. :FILARRAY
  338. FILPOS
  339. JUSTFNAME
  340. NEXTDBF
  341. MEMOWIDTHz
  342. FOXAPP2.0
  343. DBFLIST
  344. Retrieving stored relationships.
  345. dbflistf
  346. Where is FF
  347.  could not be found!
  348. CSTEM
  349. :NEXTDBF
  350. IN_AREA
  351. J1_AT
  352. J2_AT
  353. MEMWIDTH
  354. TNAME
  355. TINITDBFLISCTRLLINE
  356. CTRLROW
  357. CTRLCOL
  358. ENUMAREAS
  359. THIS_DBF
  360. RNUMCOLS
  361. DBFLIST
  362. CSTEMNUM
  363. CDBFNUM
  364. JUSTSTEM
  365. ALERT
  366. CLOSE_UP
  367. MAKECDX
  368. RCFLDNUM
  369. Resource file is read-only.  Not updated.
  370. FOXAPP2.0
  371. DBFLIST
  372. Existing resource record is read-only.  Not updated.
  373. dbflist[i,j]f
  374. FOXAPP2.0
  375. DBFLIST
  376. CSTEM
  377. :IN_AREA
  378. _AREA
  379. REPL_STR
  380. FILATTR
  381. STORERSC
  382. TTYPE
  383. TREADONLY
  384. CTRLROW
  385. TCTRLCOL
  386. ISNUMAREAS
  387. NUMCOLS
  388. DBFLIST
  389. EDATA
  390. CKVAL
  391. RUPDATED
  392. RSC_STOREDO
  393. FILNAME
  394. :TAGNAME
  395. CDXNAME
  396. JUSTTAG
  397. FORCEEXT
  398. OPENDBF
  399. INVERT
  400. HIGHT
  401. :WIDTH
  402. SCHEME
  403. FROMROW
  404. FROMCOL
  405. TOROW
  406. TOCOL
  407. WIND_NAME
  408. ALERT
  409. MESSG
  410. LINENO
  411. DEFINEWINDALERT
  412. TALKz
  413. CONSOLEz
  414. IN_TALK
  415. IN_CONS
  416. NDNUMLINES
  417. ALERT_ARRYREMAIN
  418. MAXLEN
  419. TTOP_ROW
  420. RYBOT_ROW
  421. TOP_COL
  422. TBOT_COL
  423. ALERT
  424. TKEYCODE
  425. Line No.: FF
  426. Program: 
  427.   Error: 
  428.  Source: 
  429. E_PROGRAM
  430. E_MESSAGE
  431. E_SOURCE
  432. DE_LINENO
  433. E_ERROR
  434. RYALERT
  435. CLOSE_UP
  436. Escape pressed.  FoxApp is terminating.
  437. E_PROGRAM
  438. E_MESSAGE
  439. E_SOURCE
  440. DE_LINENO
  441. E_ERROR
  442. RYM_QUITTINGCLOSE_UP
  443. ORIGNAME
  444. DBFNAME
  445. APPPATHLENSKIPDBFBUT)
  446. Invalid database name.
  447. Invalid database name.
  448. A screen file name is not allowed here.
  449. A menu file name is not allowed here.
  450. DBFLISTf
  451. DBFNAME
  452. ORIGNAME
  453. RSC_CHECK
  454. CLEANPATH
  455. JUSTSTEM
  456. YJUSTEXT
  457. NGJUSTFNAME
  458. FORCEEXT
  459. DBFALIAS
  460. YOPENDBF
  461. SCXNAME
  462. TSKIPDBFBUTDBFLIST
  463. TCSTEMNUM
  464. Database name:
  465. DBFNAME
  466. MYWIN
  467. DNAME
  468. OPENDBF
  469. ADDDBF
  470. YMODDBF
  471. DBFNAME
  472. OPENDBF
  473. MODDBF
  474. ORIGNAME
  475. DBFNAME
  476. Database name:
  477. DBFLISTf
  478. DBFNAME
  479. ORIGNAME
  480. RSC_CHECK
  481. OPENDBF
  482. SCXNAME
  483. YFORCEEXT
  484. GDBFLIST
  485. CSTEMNUM
  486. JUSTSTEM
  487. dbfselec.spr
  488. OPENDBF
  489. DBFNAME
  490. DBFSELEC
  491. DBFALIAS
  492. SCXNAME
  493. APPPATHLENMODSCX
  494. ADDSCX
  495. Invalid screen name.
  496. SCXNAME
  497. CLEANPATH
  498. JUSTFNAME
  499. FORCEEXT
  500. JUSTSTEM
  501. Screen file name
  502. UNTITLED.SCX
  503. SCXNAME
  504. CREATESCX
  505. Creating screen file
  506. SCXNAME
  507. CREATESCX
  508. Creating screen
  509. SCXNAME
  510. CREATESCX
  511. ADDSCX
  512. Screen file name:
  513. ORIGNAME
  514. SCXNAME
  515. Name your application:F
  516. FOXAPP.APP
  517. I named my program FoxApp.  You have to name yours something else.
  518.  is an invalid path.
  519. DBFLISTf
  520. Saving database relations and window positions.
  521. Generating application FF
  522. scaffold.prg
  523. *       
  524. *       
  525.                                                          
  526. *       
  527.  <<DATE()>>               scaffold.prg            <<TIME()>> 
  528. *       
  529.                                                          
  530. *       
  531. *       
  532.                                                          
  533. *       
  534.  Description:                                            
  535. *       
  536.  This program was automatically generated by FoxApp.     
  537. *       
  538.                                                          
  539. *       
  540. *       To run this application, type DO <<UPPER(justfname(m.appfile))>>
  541. * Set up runtime environment
  542. CREATE VIEW appview
  543. SET TALK OFF
  544. PUSH MENU _msysmenu
  545. PUSH KEY CLEAR
  546. fxapp_error = ON('ERROR')
  547. fxapp_esc   = ON('ESCAPE')
  548. SET LIBRARY TO fpath
  549. SET SAFETY OFF
  550. SAVE MACROS TO foxapp
  551. SET SAFETY ON
  552. SET DELETED ON
  553. SET ESCAPE OFF
  554. SET STEP OFF
  555. SET ECHO OFF
  556. SET PROCEDURE TO appproc.prg
  557. SET CURSOR ON
  558. CLOSE DATABASES
  559. ON ERROR DO apperror WITH PROGRAM(),MESSAGE(),MESSAGE(1),LINENO(),ERROR()
  560. IF TYPE("BAILOUT") <> "U"
  561.    RELEASE bailout
  562. ENDIF
  563. IF TYPE("DBFNAME") <> "U"
  564.    RELEASE dbfname
  565. ENDIF
  566. IF TYPE("WIN_NAME") <> "U"
  567.    RELEASE win_name
  568. ENDIF
  569. IF TYPE("FILT_EXPR") <> "U"
  570.    RELEASE filt_expr
  571. ENDIF
  572. IF TYPE("SRCHTERM") <> "U"
  573.    RELEASE srchterm
  574. ENDIF
  575. regen = .T.   && use SPR/MPR files instead of PRGs
  576. EXTERNAL SCREEN    getdest, getorder, appabout, ;
  577.                     appsrch, prtopts, prtsetup
  578. regen = .F.
  579. EXTERNAL PROCEDURE getdest, getorder, appabout, ;
  580.                     appsrch, prtopts, prtsetup
  581. PUBLIC bailout, dbfname, win_name, filt_expr, srchterm
  582. m.bailout = .F.
  583. m.dbfname = "<<m.dbfname>>"     && database name
  584. m.qprpath = justpath(m.dbfname) && query file path
  585. m.filt_expr = ""                && filter expression, if any
  586. m.srchterm = SPACE(60)          && search term
  587. * Define constants for addressing DBFLIST
  588. numareas   = <<m.numareas>>
  589. numcols    = <<m.numcols>>
  590. cstemnum   = <<m.cstemnum>>
  591. relstrnum  = <<m.relstrnum>>
  592. pfldnum    = <<m.pfldnum>>
  593. cfldnum    = <<m.cfldnum>>
  594. cdbfnum    = <<m.cdbfnum>>
  595. pdbfnum    = <<m.pdbfnum>>
  596. srownum    = <<m.srownum>>
  597. scolnum    = <<m.scolnum>>
  598. erownum    = <<m.erownum>>
  599. ecolnum    = <<m.ecolnum>>
  600. arranged   = <<m.arranged>>
  601. ctrlrow    = <<m.ctrlrow>>
  602. ctrlcol    = <<m.ctrlcol>>
  603. nextdbf    = <<m.nextdbf>>
  604. DO DefineDbf                    && define the DBFLIST array
  605. * Summon the main application menu
  606. DO <<_mname>>
  607. * Open the main database
  608. m.stem = juststem(m.dbfname)
  609. IF USED(m.stem)
  610.    SELECT (m.stem)
  611.    SELECT 0
  612.    IF !FILE(m.dbfname)
  613.       m.dbfname = GETFILE('DBF','Please locate the '+JustStem(m.dbfname)+' database')
  614.    ENDIF
  615.    IF EMPTY(m.dbfname) OR !FILE(m.dbfname)
  616.       DO alert WITH "The "+m.stem+" database could not be found."
  617.       DO cleanup
  618.       RETURN
  619.    ELSE
  620.       USE (m.dbfname)
  621.    ENDIF
  622. ENDIF
  623. * Make sure the index exists and is hooked up
  624. IF EMPTY(CDX(1))
  625.    IF !FILE(forceext(m.dbfname,'CDX'))
  626.       DO invert WITH m.dbfname
  627.    ELSE
  628.       SET INDEX TO (forceext(m.dbfname,'CDX'))
  629.    ENDIF
  630. ENDIF
  631. SET ORDER TO 1
  632. IF RECCOUNT() = 0
  633.    APPEND BLANK
  634.    IF RECCOUNT() < 10
  635.       COUNT FOR !DELETED() TO notdel
  636.       IF m.notdel = 0
  637.          APPEND BLANK  && all records were deleted!
  638.       ENDIF
  639.    ENDIF
  640. ENDIF
  641. GOTO TOP
  642. CLEAR
  643. Putting F
  644.  screen into window.
  645. SELECT F
  646. * The following line was added by FoxApp
  647. SELECT 
  648. win_name = "<<win_name>>"
  649. DO WHILE !bailout
  650.    * Set up any related databases
  651.    DO setrelat
  652.    * Display the main screen file
  653.    DO <<sc_file>>
  654. ENDDO
  655. DO cleanup
  656. RETURN
  657. *******************************************************************
  658. PROCEDURE cleanup
  659. * Clean up after the application
  660. SET PROCEDURE TO
  661. CLOSE DATABASES
  662. CLEAR WINDOWS
  663. IF SET('TALK') = 'ON'
  664.    SET TALK OFF
  665.    t_stat = 'ON'
  666.    t_stat = 'OFF'
  667. ENDIF
  668. SET TALK OFF
  669. * Restore databases, indexes and environment
  670. IF FILE("appview.vue")
  671.    SET VIEW TO appview
  672.    SET TALK OFF
  673.    DELETE FILE appview.vue
  674. ENDIF
  675. IF FILE("foxapp.fky")
  676.    RESTORE MACROS FROM foxapp
  677.    DELETE FILE foxapp.fky
  678. ENDIF
  679. IF t_stat = "ON"
  680.    SET TALK ON
  681. ENDIF
  682. POP KEY ALL
  683. POP MENU _msysmenu
  684. CLEAR PROGRAM
  685. *Restore original error and escape routines
  686. IF TYPE('fxapp_error') = 'C'
  687.    ON ERROR &fxapp_error
  688. ENDIF
  689. IF TYPE('fxapp_esc') = 'C'
  690.    ON ESCAPE &fxapp_esc
  691. ENDIF
  692. RELEASE LIBRARY fpath
  693. SET SAFETY ON
  694. RELEASE bailout, dbfname, win_name, filt_expr, srchterm, skipvar, act3
  695. RELEASE dbflist
  696. RETURN
  697. *******************************************************************
  698. PROCEDURE setrelat
  699. * This procedure opens subsidiary databases (if any) and establishes
  700. * the relations between the main database and the subsidiary
  701. * databases.  It will be empty if there are no subsidiary databases.
  702. DBFLISTf
  703. SELECT <<CHR(i+64)>>
  704. dname = "<<dbflist[i,m.cdbfnum]>>"
  705. IF !FILE(m.dname)
  706.    dname = GETFILE('DBF','Please locate the '+Juststem(m.dname)+ ' database:')
  707.    IF EMPTY(m.dname) OR !FILE(m.dname)
  708.       DO alert WITH "The "+ALLTRIM(m.dname+" database could not be found.")
  709.       DO cleanup
  710.       CANCEL
  711.    ELSE
  712.       SET PATH TO (SET('PATH') + ';' + Justpath(m.dname))
  713.       dbflist[<<i>>,m.cdbfnum]  = m.dname
  714.       dbflist[<<i>>,m.cstemnum] = juststem(m.dname)
  715.    ENDIF
  716. ENDIF
  717. USE (dname) ALIAS <<dbflist[i,m.cstemnum]>> ORDER TAG <<m.tagname>>
  718. DEFINE WINDOW <<dbflist[i,m.cstemnum]>> ;
  719.    FROM <<dbflist[i,m.srownum]>>,<<dbflist[i,m.scolnum]>> ;
  720.      TO <<dbflist[i,m.erownum]>>,<<dbflist[i,m.ecolnum]>> ;
  721.    FLOAT GROW ZOOM NOCLOSE MINIMIZE ;
  722.    COLOR SCHEME 10
  723. BROWSE LAST NOWAIT;
  724.    WINDOW <<dbflist[i,m.cstemnum]>> ;
  725.    NOAPPEND ;
  726.    COLOR SCHEME 10
  727. SELECT <<Juststem(dbflist[i,m.pdbfnum])>>
  728. <<dbflist[i,m.relstrnum]>> ADDITIVE
  729. * Restore the following line if you only want to see records in the
  730. * parent file that have related records in the child file.
  731. *SET FILTER TO FOUND('<<dbflist[i,m.cstemnum]>>')
  732. SELECT <<Juststem(m.dbfname)>>
  733. RETURN
  734. *******************************************************************
  735. PROCEDURE definedbf
  736. * Define the dbflist array
  737. PUBLIC dbflist[m.numareas,m.numcols]
  738. DBFLISTf
  739. dbflist[i,j]f
  740. DBFLIST[<<i>>,<<j>>] = <<'"'+dbflist[i,j]+'"'>>
  741. DBFLIST[<<i>>,<<j>>] = <<dbflist[i,j]>>
  742. DBFLIST[<<i>>,<<j>>] = ''
  743. *******************************************************************
  744. DEFAULTzF
  745. SET DEFAULT TO &p_path
  746. APPMENU.MPR
  747. DELETE FILE &mpr_name
  748. APPMENU.MPX
  749. DELETE FILE &mpx_name
  750. appproc.prg
  751. appmenu.mnx
  752. prtsetup.scx
  753. getdest.scx
  754. getorder.scx
  755. appabout.scx
  756. appsrch.scx
  757. fpath.plb
  758. PRGS\appproc.prg
  759. MENUS\appmenu.prg
  760. SCREENS\prtsetup.prg
  761. SCREENS\getdest.prg
  762. SCREENS\getorder.prg
  763. SCREENS\appabout.prg
  764. SCREENS\appsrch.prg
  765. LIBS\fpath.plb
  766. SET DEFAULT TO &c_path
  767. WIN_STRINGDNAME
  768. QUOTED
  769. SC_FILE
  770. STSTEM
  771. XNAME
  772. GGENERATE
  773. DBFNAME
  774. SCXNAME
  775. YFORCEEXT
  776. CREATESCX
  777. MNUNAME
  778. UTAPPFILE
  779. TVALID_NAMEJUSTFNAME
  780. ALERT
  781. ADDBS
  782. NAMEJUSTPATH
  783. RSC_STOREDSTORERSC
  784. PUTDBFLISTDBFLIST
  785. JUSTSTEM
  786. GTMFNAME
  787. NGREGEN
  788. _MNAME
  789. VCOORD
  790. RHCOORD
  791. RSCRNFILE
  792. EWIN_MSG
  793. NSTYLE
  794. NCENTER
  795. RWIDTH
  796. HEIGHT
  797. SCHEME
  798. NSCHEME2
  799. WIN_NAME
  800. RELATEDDBFCTRLROW
  801. CTRLCOL
  802. xSROWNUM
  803. SCOLNUM
  804. FLOAT
  805. CLOSE
  806. ACTIVATE
  807. SCSTEMNUM
  808. RTAGNAME
  809. CFLDNUM
  810. NUMAREAS
  811. NUMCOLS
  812. APPNAME
  813. OPPROJNAME
  814. SC_NAME
  815. DC_PATH
  816. RSP_PATH
  817. PJTNAME
  818. NMPR_NAME
  819. NMPX_NAME
  820. COPYPIECE
  821. APPPROC
  822. APPMENU
  823. PRTSETUP
  824. 12HT0LGETDEST
  825. 8SGETORDER
  826. 6APPABOUT
  827. APPSRCH
  828. HSFPATH
  829. HTK6PLB
  830. FOXAPPDIR
  831. MERGECTRL
  832. advance.spr
  833. ADVANCE
  834. NGSPR
  835. QUITTING
  836. CURRWIND
  837. GDBFNAME
  838. SKIPDBFBUTGENERATE
  839. OTHER
  840. YADDDBF
  841. GMODDBF
  842. SCXNAME
  843. ADDSCX
  844. YMODSCX
  845. RSC_CHECK
  846. RETRIEVERSNEXTDBF
  847. TGETDBFLISTCLOSE_UP
  848. COPYPIECE
  849. PUTOUT
  850. FINDSRC
  851. VERSIONDAT
  852. INVERT
  853. MERGECTRL
  854. INITDBFLIS
  855. OPENDBF
  856. CREATESCX
  857. FILATTR
  858. RELATEDDBF
  859. GETDBFLIST
  860. PUTDBFLIST
  861. MAKECDX
  862. DEFINEWIND
  863. ACTWIN
  864. ERRSHOW
  865. ALERT
  866. APPERROR
  867. APPESCAPE
  868. _Q4E12HSXE
  869. _Q4E12HT0L
  870. _Q4E12HT8S
  871. _Q4E12HTE6
  872. _Q4E12HTHS
  873. _Q4E12HTK6
  874. _Q4E12HTP0
  875. _Q4E12HTSF
  876. _Q4E12HTV8
  877. _Q4E12HTZI
  878. _Q4E12HU3J
  879. _Q4E12HU6A
  880. _Q4E12HU9T
  881. _Q4E12HUD6
  882. _Q4E12HX0F
  883. _Q4E12HX36
  884. _Q4E12HX66
  885. _Q4E12HX67
  886.  could not be located.
  887. FNAME
  888. TALKz
  889. COMPATIBLEz
  890. dbfselec
  891.  Related Databases 
  892. dbfselec.vue
  893. addbs
  894. forceext
  895. defaultext
  896. juststem
  897. justext
  898. justpath
  899. justfname
  900. DBFLISTf
  901. Database to open:
  902. dbfselec
  903. @ 0,1 GET dbfselec     PICTURE "@&N"     FROM dbflist     SIZE 14,16     DEFAULT 1     WHEN _q4e12fura()     VALID _q4e12fuur()     COLOR SCHEME 6
  904. @*VN \<Add;C\<lear
  905. @*VT \!\<OK;\?\<Cancel
  906. @*HN A\<rrange
  907. @*HN \<Show Tree
  908. dbfselec
  909. treewind
  910. CURRAREA
  911. LTALKSTAT
  912. COMPSTAT
  913. DBFSELEC
  914. ADDBS
  915. FORCEEXT
  916. DEFAULTEXTJUSTSTEM
  917. JUSTEXT
  918. JUSTPATH
  919. JUSTFNAME
  920. NEXTDBF
  921. INITDBFLISDBFLIST
  922. CSTEMNUM
  923. CDBFNUM
  924. NEWDBF
  925. FSELEC
  926. NUMAREAS
  927. ORIGDBFLISNUMCOLS
  928. SORIGNEXTDBADDCLR
  929. _Q4E12FV3FOKBUT
  930. _Q4E12FVLXARRANGE
  931. _Q4E12FVRDTREE1
  932. _Q4E12FWAO_Q4E12FWFL_Q4E12FWFNTREEWIND
  933. ARREXFLG
  934. LCTRLROW
  935. CTRLCOL
  936. NUMAREAS
  937. DBFLIST
  938. CSTEMNUM
  939. TSROWNUM
  940. SCOLNUM
  941. EROWNUM
  942. ECOLNUM
  943. ARRANGED
  944. APPGEN
  945. LISDBFSELEC
  946. ARREXFLG
  947. LCTRL
  948. RLCOL
  949. NUMAREAS
  950. DBFLIST
  951. CSTEMNUM
  952. APPGEN
  953. DBFSELEC
  954. DBFNUM
  955. NUMAREAS
  956. DBFLIST
  957. PDBFNUM
  958. CSTEMNUM
  959. treewind
  960. treewind
  961. treewind
  962. treewind
  963. DBFNUM
  964. LINDENT
  965. TREESTR
  966. DBFLIST
  967. CSTEMNUM
  968. END_ROW
  969. NEXTDBF
  970. S_COL
  971. TTREEWIND
  972. EESTR
  973. NUMAREAS
  974. PDBFNUM
  975. SHOWTREE
  976. DBFSELEC
  977. LNEXTDBF
  978. ADDCLR
  979. HASCHILD
  980. Main database.
  981. relselec.spr
  982. DBFSELEC
  983. LNEWDBF
  984. DBFLIST
  985. CSTEMNUM
  986. CHILDFLD
  987. CFLDNUM
  988. CHILDDBF
  989. CDBFNUM
  990. TPARENTFLD
  991. PFLDNUM
  992. IGNCASE
  993. RELSTR
  994. RELSTRNUM
  995. PARENTDBF
  996. PDBFNUM
  997. ADDMODE
  998. RELSELEC
  999. JUSTSTEM
  1000. There are no available work areas left.
  1001. Database to open:
  1002. Duplicate database names are not allowed.
  1003. relselec.spr
  1004. You cannot clear the main database.
  1005. You cannot clear a database that has related databases.
  1006. ADDCLR
  1007. LNEXTDBF
  1008. NUMAREAS
  1009. NEWDBF
  1010. JUSTEXT
  1011. JUSTSTEM
  1012. DBFLIST
  1013. TCSTEMNUM
  1014. CHILDFLD
  1015. CHILDDBF
  1016. PARENTFLD
  1017. IGNCASE
  1018. RELSTR
  1019. PARENTDBF
  1020. RELSELEC
  1021. MAKECDX
  1022. RELSTRNUM
  1023. PFLDNUM
  1024. CFLDNUM
  1025. CDBFNUM
  1026. SPDBFNUM
  1027. BSROWNUM
  1028. SCOLNUM
  1029. 3FEROWNUM
  1030. ECOLNUM
  1031. LXDBFSELEC
  1032. ARRANGE
  1033. RDHASCHILD
  1034. NUMCOLS
  1035. Saving database relations and window positions.
  1036. dbfselec.vue2
  1037. dbfselec.vue
  1038. dbfselec.vue2
  1039. dbfselec.vue
  1040. OKBUT
  1041. LRELATEDDBFSTORERSC
  1042. PUTDBFLISTDBFLIST
  1043. CSTEMNUM
  1044. ORIGDBFLISNEXTDBF
  1045. TORIGNEXTDBDBFSELEC
  1046. treewind
  1047. treewind
  1048. \<Arrange
  1049. ALT+A
  1050. \<Save
  1051. \<Exit
  1052. \Window
  1053. \Edit
  1054. DO arrsave
  1055. DO arrexit
  1056. Control panel
  1057. Control panel
  1058. treewind
  1059. ARREXFLG
  1060. LTREE_UP
  1061. FAPPGEN
  1062. DBFSELEC
  1063. TTREEWIND
  1064. ARRANGE
  1065. ARNGPOP
  1066. ISARR_SCRN
  1067. TCTRLROW
  1068. DBCTRLCOL
  1069. SCTRL
  1070. SCXNAME
  1071. DBFLIST
  1072. CSTEMNUM
  1073. MAXLEN
  1074. MAXHEIGHT
  1075. MAXCAPT
  1076. KECDX
  1077. FXSCXNME
  1078. WIDTH
  1079. HEIGHT
  1080. ARRANGED
  1081. SNEXTDBF
  1082. BSTART_ROW
  1083. END_ROW
  1084. START_COL
  1085. END_COL
  1086. LXSROWNUM
  1087. SCOLNUM
  1088. NUMAREAS
  1089. WIN_HEIGHTWS_ROW
  1090. GHTWS_COL
  1091. GHTWE_ROW
  1092. WE_COL
  1093. GHTEROWNUM
  1094. HTECOLNUM
  1095. treewind
  1096. \<Show tree
  1097. No tree to show!
  1098. Database tree
  1099. \<Hide tree
  1100. TREEWIND
  1101. LTREE1
  1102. FNEXTDBF
  1103. START_ROW
  1104. END_ROW
  1105. START_COL
  1106. END_COL
  1107. ISSHOWTREE
  1108. NEXTDBF
  1109. LARRANGE
  1110. treewind
  1111. CURRWIND
  1112. LTREEWIND
  1113. FSHOWTREE
  1114. ARRSAVE
  1115. ARREXIT
  1116. HASCHILD
  1117. SHOWTREE
  1118. _Q4E12FURA
  1119. _Q4E12FUUR
  1120. _Q4E12FV3F
  1121. _Q4E12FVLX
  1122. _Q4E12FVRD
  1123. _Q4E12FWAO
  1124. _Q4E12FWFL
  1125. _Q4E12FWFN
  1126. TALKz
  1127. COMPATIBLEz
  1128. relselec
  1129.  Database Relations 
  1130. addbs
  1131. forceext
  1132. defaultext
  1133. juststem
  1134. justext
  1135. justpath
  1136. justfname
  1137. Please locate the F
  1138.  database
  1139. relselec
  1140. @*VN \!\<OK;\?\<Cancel
  1141. How is this database connected to the others?
  1142. Fields in
  1143. Fields in
  1144. Other Databases:
  1145. This database:
  1146. relselec
  1147. CHILDSTEM
  1148. CHILDDBF
  1149. CHILDFLD
  1150. PARENTFLD
  1151. IGNCASE
  1152. RELSTR
  1153. PARENTDBF
  1154. ADDMODE
  1155. DMODE
  1156. CHILDLIST
  1157. PARENTLISTCURRAREA
  1158. TALKSTAT
  1159. COMPSTAT
  1160. RELSELEC
  1161. ADDBS
  1162. FORCEEXT
  1163. DEFAULTEXTJUSTSTEM
  1164. JUSTEXT
  1165. JUSTPATH
  1166. JUSTFNAME
  1167. IN_AREA
  1168. PARENTROW
  1169. ILDSTEM
  1170. ADDTYPE
  1171. CHILDROW
  1172. NEWCHILD
  1173. NEWPARENT
  1174. CDISLIST
  1175. _Q4E12FZRI_Q4E12FZUJOKCANCL
  1176. _Q4E12FZXF_Q4E12G05JS
  1177. FLDNAME
  1178. FLDNAME
  1179. RETVAL
  1180. CURITEM
  1181. SOURCETYPETARGTYPE
  1182. RENTFLD
  1183. GETTYPE
  1184. PECHILDLIST
  1185. PARENTLIST
  1186. CDISLIST
  1187. CHILDLIST
  1188. CHILDFLD
  1189. The child database could not be found.
  1190. The parent database could not be found.
  1191. SET RELATION TO F
  1192.  INTO 
  1193. Parent and child have different data types.
  1194. PARENTFLD
  1195. CHILDFLD
  1196. OKCANCL
  1197. DBFPART
  1198. RELSTR
  1199. TPARENTDBF
  1200. ADDMODE
  1201. CHILDSTEM
  1202. CHILDDBF
  1203. CURRWIND
  1204. PARENTFLD
  1205. GETTYPE
  1206. CHILDFLD
  1207. OKCANC
  1208. ADDTYPE
  1209. GETTYPE
  1210. CDISLIST
  1211. _Q4E12FZRI
  1212. _Q4E12FZUJ
  1213. _Q4E12FZXF
  1214. _Q4E12G05J
  1215. FoxPro Library must be loaded by FoxPro
  1216. $-c%7@
  1217.                                         
  1218. ZY[X=
  1219. WPSQR
  1220. UWPSQR
  1221. UWPSQR
  1222. UVWQS
  1223. [Y_^]
  1224. [Y_^]
  1225. UVWQSR
  1226. [Y_^]
  1227. u    6;L
  1228. UVWQS
  1229. [Y_^]
  1230. RQSUVW
  1231. _^][YZ
  1232. UWVQS
  1233. X[Y^_]
  1234. ZY[X]
  1235. ZY[X]
  1236. !Stack Overflow!
  1237. ^Y[]M
  1238. ^Y[]M
  1239. _^Y[]M
  1240. ^Y[]M
  1241. ^Y[]M
  1242. ^Y[]M
  1243. ^Y[]M
  1244. ^Y[]M
  1245. ^Y[]M
  1246. ^Y[]M
  1247. _^Y[]M
  1248. _^Y[]M
  1249. _^Y[]M
  1250. _^Y[]M
  1251. 0123456789abcdefghijklmnopqrstuvwxyz
  1252. <0r!<9w
  1253. tX<et
  1254. <0r(<9w$
  1255. SQRVW
  1256. _^ZY[]M
  1257. ?C~#OS
  1258. Floating-point support not loaded
  1259. <fr    v0<gt
  1260. Invalid memo size
  1261. Error reading memo field
  1262. CueaaaaceeeiiAAEaAooouuyOUaiounN
  1263. Data type mismatch
  1264. Not a BCD Real
  1265.    The quick     brown    fox    jumps over the lazy dog.      
  1266. The ALLTRIM test
  1267. The REDUCE test
  1268. The DELETE test
  1269. The INSERT test
  1270. Inserted: 
  1271. The CHRTRAN test
  1272. The OCCURS test
  1273.   Count the number of 'e' characters in string.
  1274. The AT test
  1275.   Find the position of the first 's'
  1276. The RAT test
  1277.   Find the position of the last 's'
  1278. The REPLICATE test
  1279.   Make 5 'z' characters.
  1280. The STRALLTRAN test
  1281. the lazy
  1282. the crazy
  1283. The PADL test
  1284. The PADR test
  1285. The SPACES test
  1286. The STUFF test
  1287. The WORDS test
  1288. There are 
  1289.  words in the string.
  1290. The WORDNUM test
  1291. The FCTNPARM test
  1292. function(a+b,c+d,foo(e-f+g,h),i)
  1293. acosh
  1294. log10
  1295. atanh
  1296. atan2
  1297. dpowi
  1298. ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890_^$~!#%&-{}()@`:.'
  1299. ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890_^$~!#%&-{}()@`:.'\
  1300. 8888888888
  1301. XXXXXXHHHHHHHHHHHHHHHHHHHH
  1302.  Jb0@
  1303. ?{Q}<
  1304. =@[V6
  1305. JUSTFNAME
  1306. JUSTSTEM
  1307. JUSTEXT
  1308. JUSTPATH
  1309. JUSTDRIVE
  1310. FORCEEXT
  1311. DEFAULTEXT
  1312. ADDBS
  1313. VALIDPATH
  1314. CLEANPATH
  1315. REDUCE
  1316. ?,.C,.I
  1317. STRFILTER
  1318. EUROSORT
  1319. ?,.C,.C
  1320. WORDS
  1321. WORDNUM
  1322. ?,I,.C
  1323. NEXTWORD
  1324. FCTNPARM
  1325. DBL2NUM
  1326. NUM2DBL
  1327. FLOAT2NUM
  1328. LONG2NUM
  1329. INT2NUM
  1330. FPATHTEST
  1331. TALKz
  1332. COMPATIBLEz
  1333. advance
  1334.  Advanced Options 
  1335. addbs
  1336. forceext
  1337. defaultext
  1338. juststem
  1339. justext
  1340. justpath
  1341. justfname
  1342. advance
  1343. @*RVN \<Abbreviated projects;\<Full projects
  1344. Project generation method:
  1345. @*C \<Store relations
  1346. @*HN \!\<OK;\?\<Cancel
  1347. @*C \<Retrieve relations
  1348. Resource file options:
  1349. advance
  1350. CURRAREA
  1351. TALKSTAT
  1352. COMPSTAT
  1353. ADVANCE
  1354. ADDBS
  1355. FORCEEXT
  1356. DEFAULTEXTJUSTSTEM
  1357. JUSTEXT
  1358. JUSTPATH
  1359. JUSTFNAME
  1360. REGEN
  1361. FULLPROJ
  1362. ORIGRETRIERETRIEVERSORIGSTORE
  1363. STORERSC
  1364. ADVOK
  1365. _Q4E12GC3To
  1366. ADVOK
  1367. REGEN
  1368. FULLPROJ
  1369. FINDSRC
  1370. FOXAPPDIR
  1371. RETRIEVERSORIGRETRIESTORERSC
  1372. ORIGSTORE
  1373. _Q4E12GC3T
  1374. SCREENS\APPSCX.SPR
  1375. C:\FOXPRO2\FOXAPP\
  1376. PRGS\APPSHELL.PRG
  1377. SCREENS\DBFSELEC.SPR
  1378. SCREENS\RELSELEC.SPR
  1379. C:\FOXPRO2\FOXAPP\LIBS\
  1380. SCREENS\ADVANCE.SPR
  1381. APPSCX.SPX
  1382. APPSHELL.FXP
  1383. DBFSELEC.SPX
  1384. RELSELEC.SPX
  1385. FPATH.PLB
  1386. ADVANCE.SPX
  1387.